"""initial

Revision ID: 1e8431842d98
Revises: 
Create Date: 2023-06-07 14:29:30.566708

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = '1e8431842d98'
down_revision = None
branch_labels = None
depends_on = None


def upgrade():

    op.execute("create sequence storage_type_lsn_seq")
    op.execute("create sequence suggest_lsn_seq")
    op.execute("create sequence order_type_lsn_seq")
    op.execute("create sequence order_lsn_seq")
    op.execute("create sequence move_lsn_seq")
    op.execute("create sequence move_log_lsn_seq")
    op.execute("create sequence location_lsn_seq")
    op.execute("create sequence location_type_lsn_seq")
    op.execute("create sequence lot_lsn_seq")
    op.execute("create sequence product_storage_type_lsn_seq")
    op.execute("create sequence quant_lsn_seq")
    op.execute("create sequence bus_lsn_seq")
    op.execute("create sequence channel_lsn_seq")
    op.execute("create sequence product_lsn_seq")
    op.execute("create sequence product_category_lsn_seq")
    op.execute("create sequence permission_lsn_seq")
    op.execute("create sequence role_lsn_seq")
    op.execute("create sequence partner_lsn_seq")
    op.execute("create sequence uom_lsn_seq")
    op.execute("create sequence uom_category_lsn_seq")
    op.execute("create sequence company_lsn_seq")
    op.execute("create sequence user_lsn_seq")
    op.execute("create sequence store_lsn_seq")


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    # ### end Alembic commands ###
    op.execute("drop sequence storage_type_lsn_seq")
    op.execute("drop sequence suggest_lsn_seq")
    op.execute("drop sequence order_type_lsn_seq")
    op.execute("drop sequence order_lsn_seq")
    op.execute("drop sequence move_lsn_seq")
    op.execute("drop sequence move_log_lsn_seq")
    op.execute("drop sequence location_lsn_seq")
    op.execute("drop sequence location_type_lsn_seq")
    op.execute("drop sequence lot_lsn_seq")
    op.execute("drop sequence product_storage_type_lsn_seq")
    op.execute("drop sequence quant_lsn_seq")
    op.execute("drop sequence channel_lsn_seq")
    op.execute("drop sequence bus_lsn_seq")
    op.execute("drop sequence product_lsn_seq")
    op.execute("drop sequence product_category_lsn_seq")
    op.execute("drop sequence permission_lsn_seq")
    op.execute("drop sequence role_lsn_seq")
    op.execute("drop sequence partner_lsn_seq")
    op.execute("drop sequence uom_lsn_seq")
    op.execute("drop sequence uom_category_lsn_seq")
    op.execute("drop sequence company_lsn_seq")
    op.execute("drop sequence user_lsn_seq")
    op.execute("drop sequence contractor_lsn_seq")
    op.execute("drop sequence store_lsn_seq")

